Enterprise Integrations Analyst*
Description
We are seeking a hands-on Senior Snowflake / Data Engineer with deep expertise in building scalable, reliable, and high-performance data platforms using Snowflake and AWS.The ideal candidate has strong experience designing production-grade data pipelines, developing complex transformations, modeling enterprise data, optimizing Snowflake workloads, and integrating data from systems such as Salesforce, APIs, SaaS platforms, and AWS services.This role will be responsible for building the data foundation that powers analytics, operational workflows, enterprise integrations, reporting, and AI applications.
What You'll Do
Snowflake Engineering
Design, build, and maintain scalable data solutions on Snowflake
Develop databases, schemas, tables, views, secure views, stages, and other Snowflake objects
Build production-grade SQL and Snowpark-based transformations
Implement Snowflake Streams, Tasks, Dynamic Tables, Snowpipe, and related capabilities
Design incremental processing and change-data-capture patterns
Optimize Snowflake queries, warehouses, clustering strategies, and storage patterns
Monitor and optimize Snowflake compute consumption and platform costs
Implement secure data-sharing and access patterns
Data Pipeline Development
Build robust ETL/ELT pipelines for structured and semi-structured data
Develop batch, incremental, near-real-time, and event-driven ingestion pipelines
Integrate data from Salesforce, REST APIs, SaaS applications, AWS, databases, and file-based sources
Implement reusable ingestion and transformation frameworks
Build pipelines capable of handling schema evolution, late-arriving data, retries, and replay
Develop reconciliation processes to ensure source-to-target completeness and accuracy
Build orchestration workflows with appropriate dependency and failure management
Data Modeling
Design scalable analytical and operational data models
Build dimensional models, fact and dimension tables, data marts, and curated datasets
Translate complex source-system structures into standardized enterprise data models
Establish consistent definitions for core business entities and metrics
Design data layers that support analytics, reporting, operational applications, and AI workloads
Balance performance, usability, maintainability, and storage efficiency in data-model design
Salesforce Data Integration
Build reliable pipelines ingesting Salesforce objects and related data into Snowflake
Work with Salesforce APIs, Bulk API, Change Data Capture, and Platform Events where appropriate
Handle Salesforce relationships, custom objects, schema changes, and large-volume datasets
Build incremental and CDC-based synchronization patterns
Implement reconciliation and data-quality controls between Salesforce and Snowflake
AWS Integration
Build data pipelines using AWS services such as S3, Lambda, SQS, SNS, EventBridge, and related technologies
Design secure data movement between AWS and Snowflake
Build event-driven ingestion and processing workflows
Manage file-based ingestion, staging, and archival patterns
Implement appropriate IAM, encryption, secrets management, and access controls
Data Quality & Observability
Implement automated data-quality validation and testing
Build monitoring for pipeline freshness, completeness, accuracy, and failures
Implement logging, metrics, alerts, and operational dashboards
Establish source-to-target reconciliation processes
Investigate and resolve production data incidents
Identify upstream and downstream impacts of data changes
Performance & Cost Optimization
Analyze query profiles and optimize expensive Snowflake workloads
Optimize warehouse sizing, auto-suspend, auto-resume, and workload isolation
Improve SQL performance and data-processing efficiency
Monitor storage and compute consumption
Identify opportunities to reduce pipeline runtime and infrastructure cost
Engineering Excellence
Write clean, reusable, testable, and maintainable code
Participate in architecture and code reviews
Build automated testing into data pipelines
Maintain technical documentation, data mappings, and runbooks
Contribute to CI/CD and automated deployment practices
Mentor other Data Engineers and help establish engineering standards
What You'll Bring
- 5+ years of data engineering experience
- 3+ years of strong hands-on Snowflake experience
- Advanced SQL skills, including complex transformations and query optimization
- Strong Python skills for data processing, automation, and API integrations
- Experience building production-grade ETL/ELT pipelines
- Experience integrating Snowflake with AWS
- Experience ingesting data from Salesforce or similar enterprise SaaS platforms
- Strong understanding of dimensional modeling and modern data architecture
- Experience with incremental processing, CDC, and data reconciliation
- Experience implementing data-quality and monitoring frameworks
- Experience with Git, CI/CD, and software engineering best practices
Nice-to-Have
- Experience with Snowpark
- Experience with Snowflake Cortex
- Experience with Streams, Tasks, Dynamic Tables, Snowpipe, and secure data sharing
- Experience with Salesforce Bulk API, CDC, and Platform Events
- Experience with AWS Lambda, S3, SQS, SNS, EventBridge, and Glue
- Experience with dbt or similar transformation frameworks
- Experience with Airflow, Dagster, Prefect, or similar orchestration platforms
- Experience with Terraform or infrastructure-as-code
- Experience supporting AI/ML and RAG workloads from Snowflake
- Snowflake certifications are a plus
What We Offer
- Enjoy flexible paid time off options for enhanced work-life balance.
- Comprehensive health insurance tailored for you.
- Employee assistance programs cover mental health, legal, financial, wellness, and behaviour areas to ensure your overall well-being.
- Complimentary CalmApp subscription for you and your loved ones, because mental wellness matters.
- Energetic work environment with a hybrid work style, providing the balance you need.
- Benefit from our family leave program, which grows with your tenure at Meltwater.
- Thrive within our inclusive community and seize ongoing professional development opportunities to elevate your career.
About Meltwater
At Meltwater, we believe that when you have the right people in the right environment, great things happen. Our best-in-class technology empowers our 27,000 customers around the world to make better business decisions through data. But we can’t do that without our global team of developers, innovators, problem-solvers, and high-performers who embrace challenges and find new solutions for our customers.Our award-winning global culture drives everything we do and creates an environment where our employees can make an impact, learn every day, feel a sense of belonging, and celebrate each other’s successes along the way. We are innovators at the core who see the potential in people, ideas and technologies. Together, we challenge ourselves to go big, be bold, and build best-in-class solutions for our customers.We’re proud of our diverse team of 2,200+ employees in 50 locations across 25 countries around the world. No matter where you are, you’ll work with people who care about your success and get the support you need to unlock new heights in your career.
We are Meltwater. Inspired by innovation, powered by people.
Where You'll Work: Hyderabad
Equal Opportunity Employer
Meltwater is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind: At Meltwater, we are dedicated to fostering an inclusive and diverse workplace where every employee feels valued, respected, and empowered. We are committed to the principle of equal employment opportunity and strive to provide a work environment that is free from discrimination and harassment. All employment decisions at Meltwater are made based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, marital status, veteran status, or any other status protected by the applicable laws and regulations. Meltwater does not tolerate discrimination or harassment of any kind, and we actively promote a culture of respect, fairness, and inclusivity. We encourage applicants of all backgrounds, experiences, and abilities to apply and join us in our mission to drive innovation and make a positive impact in the world. We may use AI to assist in aspects of our hiring process, such as reviewing candidate information, capturing interview notes, and supporting interview activities. These tools are used only to assist our team through increased efficiencies. Every output continues to be reviewed by humans, and all hiring decisions are made by humans. We remain committed to evaluating candidates fairly, consistently, and in compliance with all applicable laws